Computer Science for IGCSE & O level - Databases (Section 1 - No. 32)
What would the SQL command be to display the family name, other names and email address in alphabetical order of the family name?
SELECT FamilyName, OtherNames, EmailAddress FROM Students ORDER BY FamilyName;
SELECT * FROM Students ORDER BY FamilyName;
SHOW FamilyName, OtherNames, EmailAddress FROM Students SORT BY FamilyName;
ORDER BY FamilyName SELECT FamilyName, OtherNames, EmailAddress FROM Students;
Forklaring
The correct command uses SELECT to choose the columns, and ORDER BY to sort by FamilyName.